﻿CREATE TABLE [dbo].[tblRest_FileNames] (
	[id] INT IDENTITY(1, 1) NOT NULL,
	[database_name] [nvarchar](256) NOT NULL,
	[filegroup_name] [nvarchar](128) NULL,
	[file_number] [int] NOT NULL,
	[logical_name] [nvarchar](128) NOT NULL,
	[directory_name] [nvarchar](128) NOT NULL,
	[file_name] [nvarchar](256) NOT NULL,
	[file_type] [char](1) NOT NULL,
	[physical_name] [nvarchar](4000) NOT NULL,
	CONSTRAINT [PK_tblRest_FileNames] PRIMARY KEY ([id])
	)
GO

CREATE INDEX [IX_tblRest_FileNames_DbName] ON [dbo].[tblRest_FileNames] ([database_name])
GO